<?
require_once("../config/dbconn.php");require_once("../config/usercls.php");require_once("../config/pagecls.php");require_once("pwd1cls.php");
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	
}
td{
font-size:12px;
}
-->
</style>

<link href="images/skin.css" rel="stylesheet" type="text/css" />
</head>
<body>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" height="29" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td width="935" height="29" valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
        <td height="31"><div class="titlebt">月奖金列表</div></td>
      </tr>
    </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td height="71" valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9"><table width="100%" height="138" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="13" valign="top">&nbsp;</td>
      </tr>
      <tr>
        <td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr>
              <td><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="nowtable">
                <tr>
                  <td align="center" class="left_bt2"><form name="form1" method="post" action="?action=query">
                    期数：
                    <label>
                    <select name="periods">
					<option value="">全部期数</option>
                      <?
		  $sqlpr="select * from {$db_prefix}salarym where state>=1";
		  $resultpr=$db->query($sqlpr);
		  while($rspr=$db->fetch_array($resultpr)){
		  		echo "<option value='".$rspr['periods']."'>{$rspr['periods']}</option>";
		  }
		  $db->free_result($resultpr);
		  ?>
                    </select>
                    </label>
                                    <label>
                                    <input type="submit" name="Submit" value="查询">
                                    </label>
                  </form>
                  </td>
                </tr>
              </table></td>
            </tr>
            <tr>
              <td height="30"><table width="100%" height="60" border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td height="30" align="center" bgcolor="#f2f2f2" >期数</td>
                  <td align="center" bgcolor="#f2f2f2" >会员</td>
                  <td align="center" bgcolor="#f2f2f2" >级别</td>
                  <td align="center" bgcolor="#f2f2f2" >职位级别</td>
                  <td align="center" bgcolor="#f2f2f2" >是否已经发放</td>
                  <td align="center" bgcolor="#f2f2f2" >发放时间</td>
                  <td align="center" bgcolor="#f2f2f2" ><strong>培育奖</strong></td>
                  <td align="center" bgcolor="#f2f2f2" ><strong>复消奖</strong></td>
                  <td align="center" bgcolor="#f2f2f2" >旅游奖</td>
                  <td align="center" bgcolor="#f2f2f2" >名车奖</td>
                  <td align="center" bgcolor="#f2f2f2" ><strong>分红奖</strong></td>
                  <td align="center" bgcolor="#f2f2f2" >全部奖金</td>
                </tr>
  <?
  $query='';
  if ($action=='query'){
  	if (trim($periods)!='') $query.=" and periods='".trim($periods)."'";
  }
  $sql="select count(id) as c  from {$db_prefix}salarym1 where userid='".$_SESSION['sys_userid']."' and isff=1";
  if ($query!='') $sql.=$query;
  $rs=$db->get_one($sql);
  $page=new pagecls(20,intval($rs['c']));
  $sql="select * from {$db_prefix}salarym1 where userid='".$_SESSION['sys_userid']."' and isff=1";
  if ($query!='') $sql.=$query;
  $sql.=" order by id desc limit {$page->pastnum},{$page->pagesize}";
  $result=$db->query($sql);
  while($rs=$db->fetch_array($result)){
  	$total=0;
  ?>
                <tr>
                  <td height="30" align="center"><label></label>
                    <?=$rs['periods']?></td>
                  <td align="center"><?=$rs['username']?>                      </td>
                  <td align="center" ><?=$hyrankary[$rs['rank']]?></td>
                  <td align="center" ><?=$hyrank1ary[$rs['rank1']]?></td>
                  <td align="center" ><? if ($rs['isff']==1) echo "已经发放";else echo "没有发放";?></td>
                  <td align="center" ><? if ($rs['fftime']) echo date("Y-m-d H:i:s",$rs['fftime'])?></td>
                  <td align="center" ><?
				  $total+=$rs['pyjprice'];
				  echo $rs['pyjprice'];
				  ?></td>
                  <td align="center" ><?
				  $total+=$rs['cfxfprice'];
				  echo $rs['cfxfprice'];
				  ?></td>
                  <td align="center" ><?
				  $total+=$rs['lvprice'];
				  echo $rs['lvprice'];
				  ?></td>
                  <td align="center" ><?
				  $total+=$rs['mcprice'];
				  echo $rs['mcprice'];
				  ?></td>
                  <td align="center" ><?
				  $total+=$rs['fhprice'];
				  echo $rs['fhprice'];
				  ?></td>
                  <td align="center" ><?=$total?></td>
                </tr>
	<?
  }
  $db->free_result($result);
  ?>
              </table></td>
            </tr>
            
            <tr>
              <td height="30">&nbsp;</td>
            </tr>
            <tr>
              <td height="30" align="right">每页<?=$page->pagesize?>条 第<?=$page->pageno?>/<?=$page->pagenum?>页 共<?=$page->recnum?>条 <a href='?<?=$page->url?>1'><img src="image1/first.gif" border="0"></a>   <a href='?<?=$page->url.($page->pageno-1)?>'><img src="image1/back.gif" border="0"></a>  <a href='?<?=$page->url.($page->pageno+1)?>'><img src="image1/next.gif" border="0"></a>   <a href='?<?=$page->url.$page->pagenum?>'><img src="image1/last.gif" border="0"></a></td>
              </tr>
            <tr>
              <td height="30">&nbsp;</td>
            </tr>
          </table></td>
      </tr>
    </table></td>
    <td background="images/mail_rightbg.gif">&nbsp;</td>
  </tr>
  <tr>
    <td valign="middle" background="images/mail_leftbg.gif"><img src="images/buttom_left2.gif" width="17" height="17" /></td>
      <td height="17" valign="top" background="images/buttom_bgs.gif"><img src="images/buttom_bgs.gif" width="17" height="17" /></td>
    <td background="images/mail_rightbg.gif"><img src="images/buttom_right2.gif" width="16" height="17" /></td>
  </tr>
</table>

</body>
</html>
